Hi everyone,

I have an sql table called "category".
In this table there is one column called "module".

I CAN connect to this table - MySQL is not an option so I am connecting using the PHP built in ODBC facilities. This is not a problem.

What I would like to do is pull every row of data out of the category table and place it into a dropdown box on a php so that the users can select which module they would like.

I have found some examples using MySQL but not ODBC.

If anyone could give me some code to get me going in the right direction or a link to a website that may help I would be very grateful.

Thanks,

Simon

Have you tried using PEAR-DB?? Take a look at

http://pear.php.net/manual/en/package.database.php#package.database.db]PEAR Database Reference (http://pear.php.net/manual/en/package.database.php#package.database.db)

That should provide you with exactly what you need.

Kork